Senior Consultant | OTBI | Kolkata | HR Transformation

Job Summary:We are seeking a Manager with expertise in Oracle OTBI (Oracle Transactional Business Intelligence) and Oracle BI Publisher (BIP) reports. The ideal candidate will have a strong background in designing and implementing reporting solutions using Oracle Cloud applications and have deep knowledge in developing, customizing, and optimizing reports. As a Manager, you will work with clients to understand their reporting requirements and deliver tailored, high-quality reports using OTBI and BI Publisher.Key Responsibilities:Lead the design, development, and delivery of customized OTBI and BI Publisher reports for Oracle Cloud Applications (ERP, HCM, SCM, etc.).Collaborate with functional teams to understand reporting requirements and translate them into technical specifications.Develop, customize, and optimize OTBI reports to ensure efficient and accurate reporting from Oracle Cloud applications.Build and deploy BI Publisher reports, including layouts, data models, and templates.Perform data extraction, transformation, and reporting tasks within Oracle Cloud and integrate with other applications as needed.Troubleshoot and resolve issues related to OTBI reports, BI Publisher reports, and data discrepancies.Participate in the full SDLC, from gathering requirements and designing reports to testing and deployment.Perform performance tuning on OTBI and BIP reports to improve efficiency and data retrieval times.Provide best practices and guidance to junior consultants, development teams, and end-users on Oracle reporting tools.Work closely with clients to gather feedback and ensure reports meet business needs and user expectations.Maintain and enhance existing reports, ensuring they remain aligned with business requirements and Oracle Cloud updates.Stay up to date with the latest Oracle Cloud updates and reporting tools enhancements.Qualifications:Bachelors degree in Computer Science, Information Technology, Engineering, or a related field.Minimum of 5+ years of experience in Oracle reporting, with at least 3 years of hands-on experience in Oracle OTBI and BI Publisher (BIP).Strong knowledge of Oracle Cloud applications and how OTBI/BIP integrates with these modules.Extensive experience in designing, developing, and deploying OTBI reports and BI Publisher reports.Expertise in developing custom layouts, data models, and templates in BI Publisher.In-depth understanding of Oracle Data Models, SQL, and data retrieval techniques.Familiarity with data warehousing concepts, ETL processes, and reporting best practices.Experience in performance tuning of OTBI and BIP reports.Strong troubleshooting skills to resolve issues related to data quality, report performance, and functional requirements.Knowledge of other Oracle tools like Oracle Analytics Cloud (OAC), Oracle BI, or Oracle Reports is a plus.Experience with XML, XSL, and web technologies related to BI Publisher is highly desirable.Strong communication and interpersonal skills, with the ability to work directly with clients and business stakeholders.Preferred Skills:Oracle certifications in BI, OTBI, or Oracle Analytics Cloud (OAC) are a plus.Familiarity with Oracle Cloud security and roles management related to report access.Experience in Agile project management or implementation methodologies.Familiarity with integration of OTBI/BIP with external systems or third-party tools.Personal Attributes:Strong analytical and problem-solving skills with attention to detail.Ability to work independently and manage multiple projects simultaneously.Customer-focused, with the ability to understand and address client needs effectively.Ability to mentor and guide junior consultants and team members.Strong organizational and time-management skills, with the ability to prioritize tasks efficiently.